- -* File RSALES3.FEX
DEFINE FILE GGORDER
SALE_AMOUNT/D12 = QUANTITY * UNIT_PRICE;
YEAR/YY = ORDER_DATE;
QUARTER/Q = ORDER_DATE;
END
TABLE FILE GGORDER
ON TABLE SET PAGE-NUM OFF
SUM SALE_AMOUNT AS ''
BY YEAR AS 'Year' ACROSS QUARTER AS 'Quarter'
HEADING CENTER
"Gotham Grinds"
"Corporate Sales Report"
ON TABLE ROW-TOTAL
ON TABLE NOTOTAL
WHERE YEAR EQ '1995' OR '1996';
ON TABLE HOLD AS RSALES3A FORMAT HTMTABLE
ON TABLE SET STYLE RSALES30
END
-HTMLFORM hsales3
|
- UNITS=IN, PAGESIZE='Letter',
LEFTMARGIN=0.250000, RIGHTMARGIN=0.250000,
TOPMARGIN=0.250000, BOTTOMMARGIN=0.250000,
SQUEEZE=ON,
ORIENTATION=PORTRAIT, $
DEFMACRO=LOWSALES, MACTYPE=RULE, WHEN=N2 LT
8500000, $
DEFMACRO=HIGHSALES, MACTYPE=RULE, WHEN=N2 GT
10000000, $
TYPE=REPORT, FOCEXEC=NONE, FONT=ARIAL, SIZE=9,
COLOR=BLACK, BACKCOLOR=NONE,
STYLE=NORMAL, GRID=OFF,$
TYPE=DATA, COLUMN=N1, FOCEXEC=RSALES4(YEAR=N1), STYLE=BOLD,
$
TYPE=DATA, COLUMN=ROWTOTAL(1), COLOR=BLACK,$
TYPE=DATA, ACROSSCOLUMN=N1, COLOR=TEAL,
STYLE=BOLD, MACRO=HIGHSALES, $
TYPE=DATA, ACROSSCOLUMN=N1, COLOR=RED,
STYLE=BOLD, MACRO=LOWSALES, $
TYPE=TITLE, COLUMN=ROWTOTAL(1), STYLE=BOLD, $
TYPE=TITLE, COLUMN=N1, STYLE=BOLD, $
TYPE=TITLE, ACROSSCOLUMN=N1, STYLE=BOLD, $
TYPE=HEADING, LINE=1, OBJECT=TEXT, ITEM=1,
STYLE=BOLD, $
TYPE=HEADING, LINE=2, OBJECT=TEXT, ITEM=1,
STYLE=BOLD, $
TYPE=HEADING, LINE=3, OBJECT=TEXT, ITEM=1,
STYLE=BOLD, $
TYPE=HEADING, LINE=4, OBJECT=TEXT, ITEM=1,
SIZE=8, STYLE=BOLD, $
TYPE=ACROSSVALUE, ACROSS=1, STYLE=BOLD, $
TYPE=ACROSSTITLE, ACROSS=1, STYLE=BOLD, $
|